Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_STREAMS_NEWLY_SUPPORTED

`ALL_STREAMS_NEWLY_SUPPORTED` displays information about the tables accessible to the current user that are newly supported by Streams.

Related View

`DBA_NEWLY_SUPPORTED` displays information about all tables in the database that are newly supported by Streams.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the table
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the table
`REASON` | `VARCHAR2(32)` |  | Reason why the table was not supported in a previous release: `IOT` `column with user-defined type` `unsupported column exists` `object table` `AQ queue table` `temporary table` `sub object` `external table` `materialized view` `FILE column exists` `materialized view log` `materialized view container table` `streams unsupported object` `domain index`
`COMPATIBLE` | `CHAR(4)` |  | The latest `COMPATIBLE` setting when the table was unsupported

See Also: "DBA_STREAMS_NEWLY_SUPPORTED"